<?php

class ArticlesToTagsFixture {
	
	public $tableName = 'articles_to_tags';
	
	public $createSql = "CREATE  TABLE IF NOT EXISTS `articles_to_tags` (
	  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
	  `article_id` INT UNSIGNED NOT NULL ,
	  `tag_id` INT UNSIGNED NOT NULL ,
	  PRIMARY KEY (`id`)
	ENGINE = InnoDB";
	
	public $data = array(
		array(
			'id'			=>	1,
			'article_id'	=>	1,
			'tag_id'		=>	1,
		),
		array(
			'id'			=>	2,
			'article_id'	=>	1,
			'tag_id'		=>	2,
		),
		array(
			'id'			=>	3,
			'article_id'	=>	1,
			'tag_id'		=>	3,
		),
		array(
			'id'			=>	4,
			'article_id'	=>	2,
			'tag_id'		=>	1,
		),
		array(
			'id'			=>	5,
			'article_id'	=>	2,
			'tag_id'		=>	2,
		),
		array(
			'id'			=>	6,
			'article_id'	=>	3,
			'tag_id'		=>	4,
		),
		array(
			'id'			=>	7,
			'article_id'	=>	3,
			'tag_id'		=>	5,
		),
		array(
			'id'			=>	8,
			'article_id'	=>	4,
			'tag_id'		=>	1,
		),
		array(
			'id'			=>	9,
			'article_id'	=>	4,
			'tag_id'		=>	6,
		),
	);
	
}